ETL loading data into Destination Table in SQL from SSIS 6

ETL Process loading data into Destination Table in SQL from SSIS





Creating a new Database in SQL

1.   Open SQL.

2.   Right click on database or a database and click “New Database”. Rename it and press ok.

 

 




SSIS

1.   Open up SSIS and create project.

2.   Drag over Data Flow.

3.   Double click Data Flow

4. Drag over Excel Source

5. Drag over OLE DB Destination.






 

Excel Source

1.   Double click Excel Source.

2.   Click New and Browse for file location that you saved from Excel earlier.

3.   Choose name of excel sheet and click ok.





 

OLE DB Destination

1.   Double click OLE DB Destination.

2.   Click new top left.

3.   Click new again bottom right.

4.   Click dropdown arrow next to refresh.

5.   It may take a while but choose Server name once it populates.

6.   Choose the database name you created earlier.

7.   Test Connection.

8.   Click Ok twice.

9.   Click New where it says, “Name of table or view”.

10.   Type a table name where it says [OLE DB Destination] and click ok.

11.   Click Mappings and click ok. This is the end for OLE DB Destination.

 






1.   Click the Start button at the top of the page.

2.   The package will start to run, and you will see a total of 500 records with 2 green check marks.

3.   Head back over to SQL and refresh the database you created and SELECT * FROM (Table you created)

4.   You should see a total of 500 records loaded into that table.




 

Repeat all steps but this time around when you get to OLE DB Destination all you will have to do is choose the table name under Name of the table or the view and then execute the package.

ETL Process using SSIS [Real Time Practical Example] Step By Step

CLICK THE LINK ----> (2) ETL Process using SSIS [Real Time Practical Example] Step By Step - YouTube